package com.qf.mapper;

import com.qf.entity.DevUser;
import org.apache.ibatis.annotations.Select;
import tk.mybatis.mapper.common.Mapper;

import java.util.List;

public interface DevUserMapper extends Mapper<DevUser> {

    //查询3天未激活用户id
    @Select("select id from dev_user where dev_state=0 and created < now() - interval 3 day")
    List<Integer> findNotActiveOrderThreeDays();

}
